CREATE TABLE [dbo].[Charges]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[Name] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MinAmount] [decimal] (18, 0) NULL,
[MaxAmount] [decimal] (18, 0) NULL,
[TransactionTypeId] [int] NULL,
[AccountTypeId] [int] NULL,
[Status] [int] NULL,
[PercentageAmount] [decimal] (18, 0) NULL,
[FixedAmount] [decimal] (18, 0) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Charges] ADD CONSTRAINT [PK_Charge] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Charges] ADD CONSTRAINT [FK_Charge_AccountType] FOREIGN KEY ([AccountTypeId]) REFERENCES [dbo].[AccountTypes] ([Id])
GO
ALTER TABLE [dbo].[Charges] ADD CONSTRAINT [FK_Charge_TransactionTypes] FOREIGN KEY ([TransactionTypeId]) REFERENCES [dbo].[TransactionTypes] ([Id])
GO
